MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

13 rows where Artist Alpha Sort = 5286

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Object Name, Title, Object Date, Object Begin Date, Object End Date, Medium, Credit Line

Link rowid ▼ Object Number Is Highlight Is Public Domain Object ID Department Object Name Title Culture Period Dynasty Reign Portfolio Artist Role Artist Prefix Artist Display Name Artist Display Bio Artist Suffix Artist Alpha Sort Artist Nationality Artist Begin Date Artist End Date Object Date Object Begin Date Object End Date Medium Dimensions Credit Line Geography Type City State County Country Region Subregion Locale Locus Excavation River Classification Rights and Reproduction Link Resource Metadata Date Repository
66473 66473 1996.185.7a, b 0 0 79005 Costume Institute 8 Evening shoes 5884 Evening shoes French 7         Designer 5   René Mancini French, founded 1936   Mancini René 5286 French 2 1936 9999 1990 1990 1990 silk 15101   Gift of Anne H. Bass, 1996                           http://www.metmuseum.org/art/collection/search/79005 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
67745 67745 1994.473.2a, b 0 0 80458 Costume Institute 8 Pumps 5885 Pumps French 7         Designer 5   René Mancini French, founded 1936   Mancini René 5286 French 2 1936 9999 late 1980s 1985 1989 leather 15128   Gift of Bridget Restivo, 1994                           http://www.metmuseum.org/art/collection/search/80458 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
71081 71081 1979.89.15a, b 0 0 85439 Costume Institute 8 Evening shoes 5884 Evening shoes French 7         Designer 5   René Mancini French, founded 1936   Mancini René 5286 French 2 1936 9999 ca. 1966 1961 1971 silk, leather 15154   Bequest of Barbara C. Paley, 1978                           http://www.metmuseum.org/art/collection/search/85439 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
76099 76099 1987.134.28a, b 0 0 97808 Costume Institute 8 Boots 5898 Boots French 7         Designer 5   René Mancini French, founded 1936   Mancini René 5286 French 2 1936 9999 early 1960s 1960 1965 leather 15128   Gift of Rachel L. Mellon, 1987                           http://www.metmuseum.org/art/collection/search/97808 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
76100 76100 1987.134.29a, b 0 0 97809 Costume Institute 8 Pumps 5885 Pumps French 7         Designer 5   René Mancini French, founded 1936   Mancini René 5286 French 2 1936 9999 early 1960s 1960 1965 leather 15128   Gift of Rachel L. Mellon, 1987                           http://www.metmuseum.org/art/collection/search/97809 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
81703 81703 1979.89.14a, b 0 0 110438 Costume Institute 8 Evening shoes 5884 Evening shoes French 7         Designer 5   René Mancini French, founded 1936   Mancini René 5286 French 2 1936 9999 ca. 1965 1960 1970 silk, plastic, leather 17915   Bequest of Barbara C. Paley, 1978                           http://www.metmuseum.org/art/collection/search/110438 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
81704 81704 1979.89.16a, b 0 0 110439 Costume Institute 8 Evening shoes 5884 Evening shoes French 7         Designer 5   René Mancini French, founded 1936   Mancini René 5286 French 2 1936 9999 1966–67 1966 1967 silk, leather 15154   Bequest of Barbara C. Paley, 1978                           http://www.metmuseum.org/art/collection/search/110439 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
81705 81705 1979.89.17a, b 0 0 110440 Costume Institute 8 Evening boots 6083 Evening boots French 7         Designer 5   René Mancini French, founded 1936   Mancini René 5286 French 2 1936 9999 1966–67 1966 1967 silk, leather, metal 17039   Bequest of Barbara C. Paley, 1978                           http://www.metmuseum.org/art/collection/search/110440 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
83019 83019 1978.236.3a, b 0 0 114539 Costume Institute 8 Evening shoes 5884 Evening shoes French 7         Designer 5   René Mancini French, founded 1936   Mancini René 5286 French 2 1936 9999 ca. 1967 1962 1972 leather, metal 15127   Gift of Mrs. Henry J. Heinz II, 1978                           http://www.metmuseum.org/art/collection/search/114539 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
83381 83381 1981.249.25a, b 0 0 115684 Costume Institute 8 Boots 5898 Boots French 7         Designer 5   René Mancini French, founded 1936   Mancini René 5286 French 2 1936 9999 ca. 1968 1963 1973 leather 15128   Gift of Countess Edward Bismarck, 1981                           http://www.metmuseum.org/art/collection/search/115684 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
88562 88562 2006.420.123a, b 0 0 133868 Costume Institute 8 Shoes 5896 Shoes French 7         Designer 5   René Mancini French, founded 1936   Mancini René 5286 French 2 1936 9999 ca. 1988 1983 1993 a,b) silk 16216   Gift of Thomas L. Kempner, 2006                           http://www.metmuseum.org/art/collection/search/133868 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
95149 95149 2009.300.5625a, b 0 0 169837 Costume Institute 8 Evening pumps 5900 Evening pumps French 7         Designer 5   René Mancini French, founded 1936   Mancini René 5286 French 2 1936 9999 ca. 1965 1963 1967 Silk, rhinestones 19941   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Lauren Bacall, 1967                           http://www.metmuseum.org/art/collection/search/169837 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
95502 95502 2009.300.5997a, b 0 0 170190 Costume Institute 8 Shoes 5896 Shoes French 7         Designer 5   René Mancini French, founded 1936   Mancini René 5286 French 2 1936 9999 ca. 1963 1961 1965 Leather 732   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Jane Holzer, 1986                           http://www.metmuseum.org/art/collection/search/170190 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "MetObjects" (
"Object Number" TEXT,
  "Is Highlight" INTEGER,
  "Is Public Domain" INTEGER,
  "Object ID" INTEGER,
  "Department" INTEGER,
  "Object Name" INTEGER,
  "Title" TEXT,
  "Culture" INTEGER,
  "Period" REAL,
  "Dynasty" INTEGER,
  "Reign" INTEGER,
  "Portfolio" INTEGER,
  "Artist Role" INTEGER,
  "Artist Prefix" REAL,
  "Artist Display Name" TEXT,
  "Artist Display Bio" TEXT,
  "Artist Suffix" REAL,
  "Artist Alpha Sort" INTEGER,
  "Artist Nationality" INTEGER,
  "Artist Begin Date" TEXT,
  "Artist End Date" TEXT,
  "Object Date" TEXT,
  "Object Begin Date" INTEGER,
  "Object End Date" INTEGER,
  "Medium" INTEGER,
  "Dimensions" TEXT,
  "Credit Line" TEXT,
  "Geography Type" INTEGER,
  "City" INTEGER,
  "State" INTEGER,
  "County" INTEGER,
  "Country" INTEGER,
  "Region" INTEGER,
  "Subregion" INTEGER,
  "Locale" INTEGER,
  "Locus" INTEGER,
  "Excavation" INTEGER,
  "River" INTEGER,
  "Classification" INTEGER,
  "Rights and Reproduction" REAL,
  "Link Resource" TEXT,
  "Metadata Date" TEXT,
  "Repository" INTEGER
,
FOREIGN KEY ("Department") REFERENCES [Department](id),
    FOREIGN KEY ("Object Name") REFERENCES [Object Name](id),
    FOREIGN KEY ("Culture") REFERENCES [Culture](id),
    FOREIGN KEY ("Dynasty") REFERENCES [Dynasty](id),
    FOREIGN KEY ("Reign") REFERENCES [Reign](id),
    FOREIGN KEY ("Portfolio") REFERENCES [Portfolio](id),
    FOREIGN KEY ("Artist Role") REFERENCES [Artist Role](id),
    FOREIGN KEY ("Artist Alpha Sort") REFERENCES [Artist Alpha Sort](id),
    FOREIGN KEY ("Artist Nationality") REFERENCES [Artist Nationality](id),
    FOREIGN KEY ("Medium") REFERENCES [Medium](id),
    FOREIGN KEY ("Geography Type") REFERENCES [Geography Type](id),
    FOREIGN KEY ("City") REFERENCES [City](id),
    FOREIGN KEY ("State") REFERENCES [State](id),
    FOREIGN KEY ("County") REFERENCES [County](id),
    FOREIGN KEY ("Country") REFERENCES [Country](id),
    FOREIGN KEY ("Region") REFERENCES [Region](id),
    FOREIGN KEY ("Subregion") REFERENCES [Subregion](id),
    FOREIGN KEY ("Locale") REFERENCES [Locale](id),
    FOREIGN KEY ("Locus") REFERENCES [Locus](id),
    FOREIGN KEY ("Excavation") REFERENCES [Excavation](id),
    FOREIGN KEY ("River") REFERENCES [River](id),
    FOREIGN KEY ("Classification") REFERENCES [Classification](id),
    FOREIGN KEY ("Repository") REFERENCES [Repository](id));
CREATE INDEX ["MetObjects_Department"] ON [MetObjects]("Department");
CREATE INDEX ["MetObjects_Object Name"] ON [MetObjects]("Object Name");
CREATE INDEX ["MetObjects_Culture"] ON [MetObjects]("Culture");
CREATE INDEX ["MetObjects_Dynasty"] ON [MetObjects]("Dynasty");
CREATE INDEX ["MetObjects_Reign"] ON [MetObjects]("Reign");
CREATE INDEX ["MetObjects_Portfolio"] ON [MetObjects]("Portfolio");
CREATE INDEX ["MetObjects_Artist Role"] ON [MetObjects]("Artist Role");
CREATE INDEX ["MetObjects_Artist Alpha Sort"] ON [MetObjects]("Artist Alpha Sort");
CREATE INDEX ["MetObjects_Artist Nationality"] ON [MetObjects]("Artist Nationality");
CREATE INDEX ["MetObjects_Medium"] ON [MetObjects]("Medium");
CREATE INDEX ["MetObjects_Geography Type"] ON [MetObjects]("Geography Type");
CREATE INDEX ["MetObjects_City"] ON [MetObjects]("City");
CREATE INDEX ["MetObjects_State"] ON [MetObjects]("State");
CREATE INDEX ["MetObjects_County"] ON [MetObjects]("County");
CREATE INDEX ["MetObjects_Country"] ON [MetObjects]("Country");
CREATE INDEX ["MetObjects_Region"] ON [MetObjects]("Region");
CREATE INDEX ["MetObjects_Subregion"] ON [MetObjects]("Subregion");
CREATE INDEX ["MetObjects_Locale"] ON [MetObjects]("Locale");
CREATE INDEX ["MetObjects_Locus"] ON [MetObjects]("Locus");
CREATE INDEX ["MetObjects_Excavation"] ON [MetObjects]("Excavation");
CREATE INDEX ["MetObjects_River"] ON [MetObjects]("River");
CREATE INDEX ["MetObjects_Classification"] ON [MetObjects]("Classification");
CREATE INDEX ["MetObjects_Repository"] ON [MetObjects]("Repository");
CREATE INDEX metobjects_IsHighlight ON MetObjects("Is Highlight");
CREATE INDEX metobjects_IsPublicDomain ON MetObjects("Is Public Domain");
CREATE INDEX metobjects_Department ON MetObjects("Department");
CREATE INDEX metobjects_Culture ON MetObjects("Culture");
CREATE INDEX metobjects_Period ON MetObjects("Period");
CREATE INDEX metobjects_Dynasty ON MetObjects("Dynasty");
CREATE INDEX metobjects_Medium ON MetObjects("Medium");
CREATE INDEX metobjects_City ON MetObjects("City");
CREATE INDEX metobjects_State ON MetObjects("State");
CREATE INDEX metobjects_County ON MetObjects("County");
CREATE INDEX metobjects_Country ON MetObjects("Country");
CREATE INDEX metobjects_Region ON MetObjects("Region");
CREATE INDEX metobjects_Subregion ON MetObjects("Subregion");
CREATE INDEX metobjects_Locale ON MetObjects("Locale");
CREATE INDEX metobjects_Locus ON MetObjects("Locus");
CREATE INDEX metobjects_Excavation ON MetObjects("Excavation");
CREATE INDEX metobjects_River ON MetObjects("River");
Powered by Datasette · Query took 125.37ms · Data license: CC0 · Data source: metmuseum/openaccess